<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateYsMedalTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('medal', function(Blueprint $table)
		{
			$table->increments('id')->comment('主键id');
			$table->string('name', 24)->comment('勋章名称');
			$table->string('copy')->comment('文案');
			$table->string('one_copy', 100)->comment('一行文案');
			$table->string('requirement')->nullable()->comment('要求');
			$table->string('image')->nullable()->comment('未获得时图片');
			$table->string('get_image')->nullable()->comment('获得后的图片路径');
			$table->tinyInteger('group')->nullable()->default(0)->comment('勋章分类');
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('medal');
	}

}
